{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [],
   "source": [
    "import re\n",
    "from urllib.error import HTTPError\n",
    "import pandas as pd\n",
    "from textblob import TextBlob\n",
    "from textblob.exceptions import NotTranslated\n",
    "\n",
    "FILE_NAME = 'magazine_tweets.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [],
   "source": [
    "company_tweets = pd.read_csv(FILE_NAME, sep=',', names=['id', 'text'])\n",
    "company_tweets.drop_duplicates(subset='text', inplace=True)\n",
    "company_tweets.sort_values('id', inplace=True)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [
    {
     "name": "stdout",
     "text": [
      "Google translate API: daily limit usage has been reached!\n"
     ],
     "output_type": "stream"
    }
   ],
   "source": [
    "company_tweets_clean = pd.DataFrame(columns=('id', 'date', 'text', 'text_en', 'sentiment_polarity', 'sentiment_subjectivity'))\n",
    "try:\n",
    "    for i in company_tweets.index:\n",
    "        if company_tweets.at[i, 'id'] > 4158:\n",
    "            full_text = company_tweets.at[i, 'text']\n",
    "            date, tweet = full_text.split(\"Text=\")\n",
    "            date_splitted = date.split(' ')\n",
    "            \n",
    "            if date_splitted[1] == \"Sep\":\n",
    "                new_date_format = \"2019-09-{:s} {:s}\".format(date_splitted[2], date_splitted[3])\n",
    "            elif date_splitted[1] == \"Oct\":\n",
    "                new_date_format = \"2019-10-{:s} {:s}\".format(date_splitted[2], date_splitted[3])\n",
    "            else:\n",
    "                new_date_format = \"2019-11-{:s} {:s}\".format(date_splitted[2], date_splitted[3])\n",
    "            \n",
    "            tweet = ''.join(tweet.split('\\\\n'))\n",
    "            clean_tweet = ' '.join(re.sub(\"(@[A-Za-z0-9-ZÀ-ÿ]+)|([^0-9A-Za-z-ZÀ-ÿ \\t])|(\\w+://\\S+)\", \" \", tweet).split())\n",
    "            \n",
    "            phrase = TextBlob(clean_tweet)\n",
    "            try:\n",
    "                translate = TextBlob(str(phrase.translate(from_lang='pt', to='en_US')))\n",
    "                single_row = {\n",
    "                             'id': company_tweets.at[i, 'id'],\n",
    "                             'date': new_date_format,\n",
    "                             'text': str(phrase),\n",
    "                             'text_en': str(translate),\n",
    "                             'sentiment_polarity': translate.sentiment.polarity,\n",
    "                             'sentiment_subjectivity': translate.sentiment.subjectivity\n",
    "                              }\n",
    "                company_tweets_clean = company_tweets_clean.append(single_row, ignore_index=True)\n",
    "            except NotTranslated:\n",
    "                    print(\"Invalid tweet {:s}!\".format(str(phrase)))\n",
    "except HTTPError:\n",
    "    print(\"Google translate API: daily limit usage has been reached!\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "outputs": [],
   "source": [
    "final = pd.read_csv(FILE_NAME.split('.')[0] + \"_clean.csv\", sep=',')\n",
    "final.drop(final.columns[[0]], axis=1, inplace=True)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [
    {
     "name": "stdout",
     "text": [
      "       id                 date                                               text                                            text_en  sentiment_polarity  sentiment_subjectivity\n0    4159  2019-10-21 01:43:48                                   tá na hora né lu                                 it's time right lu            0.285714                0.535714\n1    4160  2019-10-21 01:56:53                    Eu gosto do programa do Faustão                      I like the program of Faustão            0.000000                0.000000\n2    4161  2019-10-21 09:24:21  não faço a mínima ideia do que significa Prova...  I have no idea what it means I'll probably eat...            0.000000                0.000000\n3    4162  2019-10-21 10:17:20  nossa uma viagem com celular novo seria tudo d...  our a trip with new cell phone would be all go...            0.418182                0.527273\n4    4163  2019-10-21 11:24:51  reclamacao magalu indignado Bom dia Lu tudo be...  magalu indignado good morning Lu alright I ask...            0.033333                0.755556\n5    4164  2019-10-21 11:25:17  RT poxa Lú aprendi que se conhece uma empresa ...  RT gosh Lu learned that you know a company aft...            0.000000                0.000000\n6    4165  2019-10-21 12:03:56                   Lu teremos Black Friday esse ano             Lu we will have Black Friday this year           -0.166667                0.433333\n7    4166  2019-10-21 12:35:58  bom dia Fiz o pagamento do boleto e no aplicat...  good morning I made the payment of the bill an...            0.700000                0.600000\n8    4167  2019-10-21 12:49:17  Atendimento do mais uma vez mostrando que é pé...  Customer service once again showing it's bad N...           -0.700000                0.666667\n9    4168  2019-10-21 13:04:23  Lu meu pedido comprado dia 29 09 ainda nem env...  Lu my order purchased day 09 09 not even shipp...            0.000000                0.000000\n10   4169  2019-10-21 13:15:12                 ee Só a galera do amorzinho hehehe                ee Just the little love guys hehehe            0.156250                0.550000\n11   4170  2019-10-21 13:47:18  alfredoneto Vai ser uma Black Friday descente ...  alfredoneto Will it be a decent Black Friday O...           -0.041667                0.316667\n12   4171  2019-10-21 13:49:57  eu não pensava q ia gostar tanto de uma operad...  I did not think I would like a carrier so much...            0.350000                0.350000\n13   4172  2019-10-21 13:50:03  RT eu não pensava q ia gostar tanto de uma ope...   RT I didn't think I would like a carrier so much            0.200000                0.200000\n14   4173  2019-10-21 14:20:02  alfredoneto Faz 1 mês que tirei um print do S9...  alfredoneto 1 month ago I took a print of the ...            0.700000                0.600000\n15   4174  2019-10-21 14:24:30           Péssimo péssimo péssimo o atendimento do                 Terrible terrible Terrible service           -1.000000                1.000000\n16   4175  2019-10-21 14:58:50  RT Magalu não fique com raiva Lembre-se que am...  RT Magalu Don't be angry Remember tomorrow is ...           -0.450000                0.800000\n17   4176  2019-10-21 15:00:52  Alguém já teve problema com a Já mandei e-mail...  Has anyone had a problem with the e-mailed to ...            0.000000                0.000000\n18   4177  2019-10-21 15:08:43  Poxa Lu até você na propaganda é uma coisa qdo...  Damn Lu to you in advertising is something tha...            0.000000                0.600000\n19   4178  2019-10-21 15:23:44  Lu pode estar chegando Que gerúndio feio Quem ...  Lu may be coming What an ugly gerund Who's you...           -0.333333                0.533333\n20   4179  2019-10-21 15:25:32  Lu do magalu quero meu Cupom de 2000 ou 1500 o...  Magalu's Lu want my Coupon 2000 or 1500 the pr...           -0.166667                0.166667\n21   4180  2019-10-21 15:41:50  Adoraria assistir no produto que comprei pelo ...  I would love to watch the product I bought thr...            0.425000                0.712500\n22   4181  2019-10-21 15:52:11                        Quero as TVs no clube da lu                      I want the TVs in the lu club            0.000000                0.000000\n23   4182  2019-10-21 16:06:05  Mentira Qual foi a tv Djair comprou uma na sex...  Lie What was the TV Djair bought one on Friday...            0.350000                0.800000\n24   4183  2019-10-21 16:21:35  uma perguntinha aqui bem fora do contexto kkk ...  a little question right here out of context kk...            0.189096                0.381710\n25   4184  2019-10-21 16:34:21  não precisa mas não Lu o pedido já chegou Obri...  no need but no Lu the order has arrived Thank ...            0.000000                0.000000\n26   4185  2019-10-21 17:15:25                             Lu vai ter o rogphone2                             Lu will have rogphone2            0.000000                0.000000\n27   4186  2019-10-21 17:23:08  Meu deus o não reconhece o pagamento do meu ce...  My God doesn't recognize my cell phone payment...            0.000000                0.000000\n28   4187  2019-10-21 17:28:47  Quero fazer uma compra mas precisava de um cup...  I want to make a purchase but I needed a disco...            0.000000                0.000000\n29   4220  2019-10-21 17:39:12  Um dia você é jovem e outro dia você está olha...  One day you are young and another day you are ...            0.475000                0.700000\n30   4221  2019-10-21 17:43:57  quando do nada a bicicleta aro 29 aumenta o preço  when out of nowhere the rim 29 bike raises the...            0.000000                0.000000\n31   4222  2019-10-21 18:05:18  RT Como tá a ansiedade para a chegada do servi...  RT How anxious is the arrival of the Disney st...           -0.250000                1.000000\n32   4223  2019-10-21 18:10:20  RT Como tá a ansiedade para a chegada do servi...  RT How anxious is the arrival of the Disney st...           -0.250000                1.000000\n33   4224  2019-10-21 18:14:35  Meu aniversário hj só ganhei parabéns da mãe e...  My birthday today I just got congratulations f...            0.000000                0.000000\n34   4225  2019-10-21 18:53:01  Magalu Boa Tarde sua linda Tdb Preciso de uma ...  Magalu Good afternoon your beautiful Tdb I nee...            0.267500                0.900000\n35   4226  2019-10-21 19:04:14  Lu quando vai voltar no site o iphone 11 pro m...  Lu when he goes back to the site the iphone 11...            0.000000                0.000000\n36   4227  2019-10-21 19:12:54  Esperava muito mais da famosa Magalu Que servi...  I expected so much more from the famous Magalu...           -0.080000                0.693333\n37   4228  2019-10-21 19:20:01  Em tempo o não resolveu meu problema VERGONHA ...  In time the did not solve my problem SHAME and...            0.000000                0.000000\n38   4229  2019-10-21 19:59:51  Queria saber como faço a troca do meu celular ...  I was wondering how do I exchange my old mobil...            0.100000                0.200000\n39   4230  2019-10-21 20:23:37  Que beleza hein Não conseguem nem fazer um ser...  What a beauty huh They can't even do a right s...            0.285714                0.535714\n40   4231  2019-10-21 20:47:11  Sinceramente compre na loja mas não compre nad...  Sincerely buy in store but buy nothing on the ...            0.500000                0.500000\n41   4232  2019-10-21 21:29:38                                   Responde a dm Lu                                       Answer dm Lu            0.000000                0.000000\n42   4233  2019-10-21 21:30:24  Eu cadê o bug da Lu pra me da um cupom pra com...  Where's Lu's bug for giving me a coupon to buy...            0.000000                0.000000\n43   4234  2019-10-21 21:58:16  Só se for cupom menor do que bola de gude cans...  Only if it is smaller coupon than already tire...           -0.133333                0.733333\n44   4235  2019-10-21 22:50:44  RT Canudos de plástico demoram centenas de ano...  RT Plastic straws take hundreds of years to de...            0.100000                0.400000\n45   4236  2019-10-21 22:53:43  Magalu pisa muito Bom saber isso das Casas Bah...  Magalu steps very good to know this from Casas...            0.910000                0.780000\n46   4237  2019-10-21 23:13:23  tá de rosca heim To novamente reclamando da ap...  ok again to complain about the approval of Fri...            0.500000                0.500000\n47   4238  2019-10-21 23:14:46  RT Canudos de plástico demoram centenas de ano...  RT Plastic straws take hundreds of years to de...            0.100000                0.400000\n48   4239  2019-10-21 23:39:32                            Luiza responde minha dm                                Luiza answers my dm            0.000000                0.000000\n49   4240  2019-10-21 23:58:19  Meus parceiros incríveis de luta diária e o tr...  My amazing daily fight partners and the trophy...            0.413889                0.416667\n50   4241  2019-10-22 01:32:31  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n51   4242  2019-10-22 02:00:39  Efetuei uma compra dia 29 09 e até o presente ...  I made a purchase on 29 09 and so far has not ...            0.100000                1.000000\n52   4243  2019-10-22 03:23:40  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n53   4244  2019-10-22 04:42:39  Olhei o meu extrato bancário e mais uma vez o ...  I looked at my bank statement and once again t...            0.285714                0.535714\n54   4245  2019-10-22 09:41:56             Nossa Lu Você acorda muito cedo Kkkkkk               Our Lu You wake up very early Kkkkkk            0.130000                0.390000\n55   4246  2019-10-22 09:42:42  Do dia que eu perdi seu cupom pq dormi dez min...  From the day I lost your coupon because I slep...            0.000000                0.000000\n56   4247  2019-10-22 09:44:08                                   Do cupom de 1500                               From the 1500 coupon            0.000000                0.000000\n57   4249  2019-10-22 09:49:13  RT Do dia que eu perdi seu cupom pq dormi dez ...  RT From the day I lost your coupon because I s...            0.000000                0.000000\n58   4250  2019-10-22 09:53:59             Saudade do que a gente ainda não viveu                  Missing what we haven't lived yet           -0.200000                0.050000\n59   4251  2019-10-22 10:05:40  O dia que você deu cupom de mil e Eu não conse...  The day you gave a thousand coupon I didn't ge...           -0.075000                0.700000\n60   4252  2019-10-22 10:11:59                           Dia do BLACK POST MAGALU                              BLACK POST MAGALU Day           -0.166667                0.433333\n61   4253  2019-10-22 10:13:43  Quando vai ser a inauguração da loja em Santa ...  When will the store open in Santa Cruz do Rio ...            0.000000                0.500000\n62   4254  2019-10-22 10:15:53  o dia que minha prima usou o cpf do meu pai e ...  the day my cousin used my father's cpf and spe...           -0.100000                0.100000\n63   4255  2019-10-22 10:22:42  Quando as TVs 4k tava no clube da lu foi assim...  When 4k TVs were at lu's club, that's how I bo...            1.000000                0.300000\n64   4256  2019-10-22 10:23:23         Mudei de casa e comprei o sofá pela magalu        I moved home and bought the sofa for magalu            0.000000                0.000000\n65   4257  2019-10-22 10:32:51                             Do galaxy 10 a R 1 400                          From galaxy 10 to R 1 400            0.000000                0.000000\n66   4258  2019-10-22 10:41:03  RT Bom dia Qual é a melhor lembrança que você ...  RT Good morning What's your best memory of Magalu            0.850000                0.450000\n67   4259  2019-10-22 10:48:48                                         Bom dia lu                                    Good morning lu            0.700000                0.600000\n68   4260  2019-10-22 10:55:12  Do dia que eu fiz uma compra pelo app não cheg...  The day I made a purchase for the app did not ...            0.000000                0.000000\n69   4261  2019-10-22 10:56:14          As felicitações no dia do meu aniversário                 The congratulations on my birthday            0.000000                0.000000\n70   4262  2019-10-22 10:56:51  Mas Falo pq o dia do Black Post Magalu pra mim...  But I speak because Black Post Magalu's day to...            0.166667                0.566667\n71   4263  2019-10-22 10:58:47  Abertura da loja onde eu moro Crateús interior...  Opening of the shop where I live Crateús inter...            0.136364                0.500000\n72   4264  2019-10-22 11:01:53  Meu pedido está como Retido na fiscalização do...  My order is as withheld from your state inspec...            0.000000                0.000000\n73   4265  2019-10-22 11:05:40         a fatura todo mês né Lu se esquecer já viu  the invoice every month right Lu forget you ev...            0.285714                0.535714\n74   4266  2019-10-22 11:08:02  o dia que eu comprei um notebook por 50 reais ...  the day i bought a notebook for 50 reais my pc...            0.000000                0.000000\n75   4267  2019-10-22 11:12:08  A sagrada madrugada que fiz a feira usando o b...  The holy dawn I made the fair using the thousa...            0.600000                0.750000\n76   4268  2019-10-22 11:17:32          RT Saudade do que a gente ainda não viveu               RT Missing what we haven't lived yet           -0.200000                0.050000\n77   4269  2019-10-22 11:17:45  Quando fui comprar a impressora A loja cheia o...  When I went to buy the printer The full store ...            0.183333                0.383333\n78   4270  2019-10-22 11:23:27  Minha compra do meu note da Vaio Comprei por u...  My purchase of my Vaio note I bought it for a ...            0.144444                0.888889\n79   4271  2019-10-22 11:28:32  o dia que deu um bug na lu e teve cupom com de...  the day that gave a bug in the lu and had a di...            0.700000                0.600000\n80   4272  2019-10-22 12:07:02              A do Bug de 1000 e eu estava dormindo           The one from Bug 1000 and I was sleeping            0.000000                0.000000\n81   4273  2019-10-22 12:15:13  esta bem complicado entender os repasses finan...  It is very complicated to understand the finan...           -0.325000                0.500000\n82   4274  2019-10-22 12:16:49  Alguém tira o app da do meu celular Porque da ...  Someone takes the app from my cell phone becau...            0.000000                0.066667\n83   4275  2019-10-22 12:24:41  Quando chegou meu fogão lindâo 10 dias antes d...  When my beautiful stove arrived 10 days before...            0.850000                1.000000\n84   4277  2019-10-22 12:27:22  comprei pela primeira vez no app e não tenho c...  I bought it for the first time in the app and ...            0.250000                0.333333\n85   4278  2019-10-22 12:28:16  Decepcionada com por me enrolar e não entregar...  Disappointed with curling up and not deliverin...           -0.350000                0.430556\n86   4279  2019-10-22 12:35:18  Lembro dos carnêzinhos de papel que minha mãe ...  I remember the little paper carnations my moth...            0.170833                0.766667\n87   4280  2019-10-22 12:43:19                     O bug da Lu somente isso mesmo                                 Lu's bug just that            0.000000                0.000000\n88   4281  2019-10-22 12:43:38  Do melhor bug que deu e consegui comprar meu c...  The best bug that I gave and I was able to buy...            0.750000                0.462500\n89   4282  2019-10-22 12:54:04  A Dona A promoção da lava e seca Lg 11kg do di...  The Dona The promotion of lava and drought Lg ...           -0.250000                0.500000\n90   4283  2019-10-22 13:13:14  Quando eu comprei primeira vez na loja magalu ...  When I first bought it at the magalu store so ...            0.116667                0.777778\n91   4284  2019-10-22 13:34:34  De quando fomos feitos de trouxa no seu aniver...  From when we were made a muggle on your birthd...            0.000000                0.000000\n92   4285  2019-10-22 13:35:25  Estes foram os resultados da semana 7 da NFL E...  These were the results of NFL Week 7. So how w...            0.000000                0.000000\n93   4286  2019-10-22 13:38:27  Lu preciso te mandar dm em relação a uma compr...  Lu need to send you dm in relation to a purcha...            0.000000                0.000000\n94   4287  2019-10-22 13:38:37  RT Estes foram os resultados da semana 7 da NF...  RT These were the results of NFL Week 7 And so...            0.000000                0.000000\n95   4288  2019-10-22 13:39:57  E pra ajudar os produtos foram pegos todos da ...  And to help the products were all taken from t...            0.000000                0.000000\n96   4289  2019-10-22 13:40:28  Galera o que a e a estão fazendo com o frete é...  Guys what they are doing with the shipping is ...           -0.066667                0.433333\n97   4290  2019-10-22 13:54:06  Aguardando ansiosa por uma promoção do Motorol...  Looking forward to a Motorola One Vision gt lt...            0.000000                0.000000\n98   4291  2019-10-22 13:56:00              Poxa MAGALU dá um cupom p minha amiga             Gee MAGALU gives a coupon to my friend            0.000000                0.000000\n99   4292  2019-10-22 13:56:29  Do dia que sonhei com o cupom de 1000 reais tô...  From the day I dreamed about the coupon of 100...            0.000000                0.000000\n100  4293  2019-10-22 14:02:53  saudades do que a gente nunca viveu inclusive ...  miss what we never lived including miss promot...            0.000000                0.000000\n101  4294  2019-10-22 14:23:41  fiz um pedido de um aparelho de jantar mas est...  I placed an order for a dinner appliance but I...           -0.466667                0.566667\n102  4295  2019-10-22 14:23:42  fiz um pedido de um aparelho de jantar mas est...  I placed an order for a dinner appliance but I...           -0.466667                0.566667\n103  4296  2019-10-22 14:27:11  PORCARIA DE LOJA Mais de 1 mês esperando meu p...  SHOP CUB More than 1 month waiting for my orde...            0.500000                0.500000\n104  4297  2019-10-22 14:27:41  RT Bom dia Qual é a melhor lembrança que você ...  RT Good morning What's your best memory of Magalu            0.850000                0.450000\n105  4298  2019-10-22 14:36:28  Aquele momento que a Lu do te manda uma mensag...  That moment Lu do sends you a meaningful congr...            0.600000                0.650000\n106  4299  2019-10-22 14:38:23  Quando comprei o cel do meu pai pelo app dentr...  When I bought my dad's cel for the app inside ...            0.052381                0.402721\n107  4300  2019-10-22 14:43:01  Fui comprar um smartphone pela internet mais a...  I went to buy a smartphone over the internet m...            0.250000                0.312500\n108  4301  2019-10-22 14:43:10  Infelizmente minha última compra numa loja fís...  Unfortunately my last purchase at a physical s...            0.054167                0.215774\n109  4302  2019-10-22 15:15:13  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n110  4303  2019-10-22 15:15:17  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n111  4304  2019-10-22 15:17:46  Parabéns magazine Luiza minha cidade de Picos ...  Congratulations magazine Luiza my city of Pico...            0.000000                0.000000\n112  4329  2019-10-22 12:24:54          RT Saudade do que a gente ainda não viveu               RT Missing what we haven't lived yet           -0.200000                0.050000\n113  4358  2019-10-22 15:29:37  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n114  4359  2019-10-22 15:30:55  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n115  4360  2019-10-22 15:38:03  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n116  4361  2019-10-22 16:02:52  Do meu celular atual pq eu tava precisando com...  From my current cell phone because I was in ur...            0.250000                0.500000\n117  4362  2019-10-22 16:13:20  -esse prazo apenas pra retirar imagina entrega...  -this deadline just to withdraw imagine handin...            0.012121                0.326515\n118  4363  2019-10-22 16:14:40  RT Você compartilha a senha da Netflix com alg...  RT Do you share Netflix password with someone ...            0.700000                0.600000\n119  4364  2019-10-22 16:19:48  cadê meu produto Já mandei o número do CPF e n...  where is my product I already sent the CPF num...            0.000000                0.000000\n120  4365  2019-10-22 16:26:55  Ainda bem que Netflix aqui em casa é coisa do ...  Glad Netflix at home is a thing of the past no...            0.105000                0.685000\n121  4366  2019-10-22 16:31:30  Melhor lembrança foi quando comprei meu smart ...  Best memory was when I bought my smart and arr...            0.438095                0.414286\n122  4368  2019-10-22 16:53:59  E olha que bacana essa reportagem que fala da ...  And look how cool this article that talks abou...            0.500000                0.679167\n123  4369  2019-10-22 16:54:12  Muito orgulho de ver essa reportagem que expli...  Very proud to see this story that explains how...            0.587500                0.800000\n124  4370  2019-10-22 16:55:12  Do Samsung Galaxy S10e que comprei por R 1 399...  From the Samsung Galaxy S10e I bought for R 1 ...            0.000000                0.000000\n125  4371  2019-10-22 17:09:09  Ter ganhado dinheiro com as ações dela através...  Making money from her actions through alaskablack            0.000000                0.000000\n126  4372  2019-10-22 17:19:25  Quando comecei a acompanhar Dona Luiza Trajano...  When I started to follow Dona Luiza Trajano ba...            0.000000                0.250000\n127  4373  2019-10-22 17:30:39               Lu mandei uma dm você pode responder                        Lu sent a dm can you answer            0.000000                0.000000\n128  4374  2019-10-22 17:30:52  oi Lu vou comprar um notebook com vc hoje me d...  Hi Lu I'll buy a notebook with you today give ...            0.000000                0.000000\n129  4375  2019-10-22 17:34:38  Minha TV que chegou muito rápido só a magalu e...      My TV that came too fast just magalu and fast            0.200000                0.600000\n130  4376  2019-10-22 17:42:17  RT Estes foram os resultados da semana 7 da NF...  RT These were the results of NFL Week 7 And so...            0.000000                0.000000\n131  4377  2019-10-22 17:45:16  De vcs não ter aprovado para eu fazer o cartão...  Since you have not approved for me to do the c...            0.000000                0.000000\n132  4378  2019-10-22 17:50:15  Equipes da de São Paulo e Rio Grande do Sul co...  Teams from Sao Paulo and Rio Grande do Sul con...            0.000000                0.000000\n133  4379  2019-10-22 18:24:56  essa é a dona da magazine Luiza Você que compr...  this is the owner of the magazine Luiza You wh...            0.000000                0.000000\n134  4380  2019-10-22 18:41:28  vascaina Olha eu cancelei minha compra porque ...  vascaina Look I canceled my purchase because i...            0.000000                0.000000\n135  4381  2019-10-22 18:49:10            Magalu me ajuda Chegaram a ver meu caso           Magalu helps me They came to see my case            0.000000                0.000000\n136  4382  2019-10-22 18:55:28  RT E olha que bacana essa reportagem que fala ...  RT And look how cool this article that talks a...            0.175000                0.358333\n137  4383  2019-10-22 18:59:47  é gigante Merecem muito terem chegado onde est...  it's giant They deserve so much to have gotten...            0.100000                0.600000\n138  4384  2019-10-22 19:14:40  Mais aí acaba a graça da internet e acaba com ...  But then the fun of the internet ends and the ...            0.300000                0.200000\n139  4385  2019-10-22 19:21:43  Inclusive Lu se rolar um desconto pra estudant...  Including Lu if a student discount a let me kn...            0.250000                0.333333\n140  4386  2019-10-22 20:03:35  RT O Magalu arrasa nas entregas mesmo Hallyson...  RT Magalu rocks deliveries even Hallyson There...            0.000000                0.000000\n141  4387  2019-10-22 20:05:22       As melhores interações kkkkkk vou esperar Lu          The best interactions kkkkkk I'll wait Lu            1.000000                0.300000\n142  4388  2019-10-22 20:31:44  E claro que de novo a ia atrasar a entrega e m...  And of course I was going to delay delivery ag...           -0.033929                0.361905\n143  4389  2019-10-22 20:45:22  Temos a doce lembrança do dia em que abrimos n...  We have the sweet memory of the day we opened ...            0.350000                0.650000\n144  4390  2019-10-22 20:57:57                                        O bug da lu                                         The lu bug            0.000000                0.000000\n145  4391  2019-10-22 21:19:53     Esses vendedores só encontro no magalu mesmo V  These sellers only encounter in the same magalu V            0.000000                0.562500\n146  4392  2019-10-22 21:25:25  Ô lu sua loja tem instrumento musical Queria c...  Your store has musical instrument I wanted to ...           -0.325000                0.500000\n147  4393  2019-10-22 21:32:14  eu só tenho saudades do que eu ainda não vivi ...  i just miss what i haven't lived with you yet ...            0.000000                0.000000\n148  4394  2019-10-22 21:51:41             RT É que aqui no Magalu é PiscouChegou          RT Is that here in Magalu is PiscouChegou            0.000000                0.000000\n149  4395  2019-10-22 22:28:13  Alo Lu tenho provas que fiquei aguardando o pe...  Hello Lu I have proof that I was waiting for t...            0.050000                0.500000\n150  4396  2019-10-22 22:30:30  Melhor lembrança é o BugDaMagalu Sdds do q a g...     Best memory is BugDaMagalu Sdds we didn't live            0.568182                0.400000\n151  4397  2019-10-22 22:52:57                                     Oi eu sou o Lu                                         Hi, I'm Lu            0.000000                0.000000\n152  4398  2019-10-22 23:00:03  Minha melhor lembrança é a que nem vivemos ain...  My best memory is that we don't even live on t...            0.568182                0.400000\n153  4399  2019-10-22 23:00:04  A Lu da falando comigo no wpp por causa da com...  Lu da talking to me on wpp because of the purc...            0.500000                0.500000\n154  4400  2019-10-22 23:00:04                                     Libera a DM Lu                                      Release DM Lu            0.000000                0.000000\n155  4401  2019-10-22 23:03:54  Eu prefiro um cupom de 1000 não tem guia melho...  I prefer a coupon of 1000 has no better guide ...           -0.250000                0.500000\n156  4402  2019-10-22 23:13:04  Chatiadissima com o atendimento do poucos dias...  Chatiadissima with the care of the few days af...           -0.050000                0.150000\n157  4403  2019-10-22 23:18:36  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n158  4404  2019-10-22 23:32:30  Oi lu quero compra um produto que na concorrên...  Hi lu want to buy a product that is cheaper co...            0.000000                0.000000\n159  4405  2019-10-23 00:11:16  Ambos são do Google Mas a ideia colaborativa d...  Both are from Google But the collaborative ide...            0.700000                0.900000\n160  4406  2019-10-23 00:20:36  Onde isso Comprei uma máquina de lavar roupas ...  Where did I buy a washing machine because of t...            0.000000                0.000000\n161  4407  2019-10-23 00:23:23  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n162  4408  2019-10-23 00:24:04  Sortudo Eu não fui contemplada com esse Piscou...  Lucky I was not contemplated with this Winked ...            0.333333                0.833333\n163  4409  2019-10-23 00:24:26  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n164  4410  2019-10-23 00:25:03  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n165  4411  2019-10-23 00:28:18  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n166  4412  2019-10-23 00:39:16  Gente atenção para você que quer atenção no di...  Attention to you who want attention on your bi...            0.100000                0.150000\n167  4413  2019-10-23 01:03:31  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n168  4414  2019-10-23 01:07:16  oi como funciona a politica de troca com lojas...  hi how the exchange policy works with partner ...            0.000000                0.000000\n169  4415  2019-10-23 01:24:49  Lu preciso de geladeira Quando vai ter aquela ...  Lu need fridge When will have that top promoti...            0.600000                0.550000\n170  4416  2019-10-23 01:31:30  manda um caneta touch daquelas baratinhas pra ...  send me a touch pen of those cheap ones 15 tal...            0.400000                0.700000\n171  4417  2019-10-23 01:32:32  Não chegou 7791500515697946 Vc Lu robozinha me...  Not 7791500515697946 You Lu robozinha sent me ...            0.000000                0.000000\n172  4418  2019-10-23 01:40:01  Novamente nada resolvido Vocês são uma piada T...  Again nothing solved You guys are a joke Treat...            0.300000                0.100000\n173  4419  2019-10-23 01:49:59  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n174  4420  2019-10-23 02:00:23  Lu hoje se inicia mais uma temporada da NBA Po...  Lu begins another NBA season today Could put t...            0.000000                1.000000\n175  4421  2019-10-23 02:09:55  RT Você prefere o Waze ou o Google Maps na hor...  RT Do you prefer Waze or Google Maps when navi...            0.136364                0.454545\n176  4422  2019-10-23 02:28:23  Ó não é pq ela viu mas vou falar Sempre dou pr...  Oh it's not because she saw but I'll talk Alwa...            0.456667                0.586667\n177  4423  2019-10-23 02:35:00  Olha aí Valoriza a cliente aí ela vale ouro tr...  Look at that value the customer then she is wo...            0.300000                0.100000\n178  4424  2019-10-23 02:45:27  Eu comprei um fone no início do ano e agora el...  I bought a headset at the beginning of the yea...           -0.207143                0.601190\n179  4425  2019-10-23 02:56:09           Sdds do que ainda não vivemos cuponzinho                   Sdds of which we do not live yet           -0.068182                0.500000\n180  4426  2019-10-23 03:18:21  Gostaria de obter informações sobre a entrega ...  I would like to inquire about the delivery of ...            0.200000                0.550000\n181  4427  2019-10-23 03:36:29  caralho eu só queria minha mesa logo pra termi...  Fuck I just wanted my desk right away to finis...           -0.057143                0.567857\n182  4428  2019-10-23 04:23:49  Lu ja ouvisse a nova música da e menecessita É...  Lu already listened to the new song of e menec...            0.136364                0.454545\n183  4429  2019-10-23 06:37:47  Lu não consigo te enviar dm Aqui não aparece d...  Lu can not send you dm Here is not available B...            0.200000                0.433333\n184  4430  2019-10-23 06:52:40                          A pior Lembrança possível                              Worst possible memory           -0.500000                1.000000\n185  4431  2019-10-23 08:25:30    pô quando o meu celular finalmente chegou né lu           when my cell phone finally arrived right            0.142857                0.767857\n186  4432  2019-10-23 09:27:33  RT Você prefere o Waze ou o Google Maps na hor...  RT Do you prefer Waze or Google Maps when navi...            0.136364                0.454545\n187  4433  2019-10-23 09:34:22               Cupom de desconto no app da Magazine                    Magazine In-App Discount Coupon            0.000000                0.000000\n188  4434  2019-10-23 09:34:42                               Os posts do Flamengo                                   Flamengo's posts            0.000000                0.000000\n189  4435  2019-10-23 09:35:14                        Aviso de promoção da Magalu                            Magalu Promotion Notice            0.000000                0.000000\n190  4436  2019-10-23 09:35:17  gosto de ver o povo falando que conseguiu comp...  I like to see the people saying that they coul...            0.136364                0.454545\n191  4437  2019-10-23 09:35:27  Cupom de desconto da magazine Luiza plmdds eu ...  Discount coupon from magazine Luiza plmdds i n...            0.136364                0.454545\n192  4438  2019-10-23 09:36:03  Cupom e bom dia do Mozão Já que não tem o bom ...  Coupon and good morning Mozão Since there is n...            0.116667                0.441667\n193  4439  2019-10-23 09:36:41                        cupom de desconto do magalu                             magalu discount coupon            0.000000                0.000000\n194  4440  2019-10-23 09:38:08                                          Bug da Lu                                             Lu bug            0.000000                0.000000\n195  4441  2019-10-23 09:42:09                       Bom dia lu Cupom de desconto                    Good morning lu Discount Coupon            0.700000                0.600000\n196  4442  2019-10-23 09:49:54  Lu como vai ser a Black Friday esse ano Quero ...  Lu how will be Black Friday this year I want t...           -0.166667                0.433333\n197  4443  2019-10-23 09:52:57  Um político dizendo Vamos diminuir o número de...  A politician saying Let's decrease the number ...            0.000000                0.000000\n198  4444  2019-10-23 09:55:02                                   Tudo que fale do                          Everything that speaks of            0.000000                0.000000\n199  4445  2019-10-23 09:56:13  Do vácuo que me deixaram ontem ate agora não m...  From the vacuum they left me yesterday so far ...            0.030556                0.333333\n200  4446  2019-10-23 09:57:36                       Gente falando mal do governo            People talking bad about the government           -0.700000                0.666667\n201  4447  2019-10-23 09:59:11  Além dos cupons de desconto no app magalu Víde...  In addition to the magalu app discount coupons...            0.500000                1.000000\n202  4448  2019-10-23 10:00:23  Se a Black Friday estiver boa mesmo quando eu ...  If Black Friday is good even when I have a dau...            0.266667                0.516667\n203  4449  2019-10-23 10:08:38  Lu quando e q vai ser o Black Friday ja tem da...  Lu when and what will be Black Friday already ...           -0.166667                0.433333\n204  4450  2019-10-23 10:10:28  Meme e um olhar mais crítico para as notícias ...  Meme and a more critical look at the news such...            0.166667                0.600000\n205  4451  2019-10-23 10:11:32                                   O robô da Magalu                                   The Magalu Robot            0.000000                0.000000\n206  4452  2019-10-23 10:12:10    A ajudando na ação para retirar óleo das praias   Helping her in action to remove oil from beaches            0.100000                0.100000\n207  4453  2019-10-23 10:15:04  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n208  4454  2019-10-23 10:18:32  RT inc Femmebot transsex amore É que esses tem...  RT inc Femmebot transsex amore Is that these t...           -0.406250                0.893750\n209  4455  2019-10-23 10:32:22  Lu eu quero esse notebook na Black Friday é o ...  Lu I want this notebook on Black Friday is the...           -0.166667                0.433333\n210  4456  2019-10-23 10:41:19                   Metade do twitter assim kkkkkkkk                 Half of twitter like this kkkkkkkk           -0.166667                0.166667\n211  4457  2019-10-23 10:41:44           RT zxhn Metade do twitter assim kkkkkkkk         RT zxhn Half of twitter like this kkkkkkkk           -0.166667                0.166667\n212  4458  2019-10-23 11:04:21  que as pessoas que eu sigo são gente como a ge...  that the people I follow are people like us un...            0.000000                0.000000\n213  4459  2019-10-23 11:28:52                    Vitórias do e tretas do governo                       Government wins and bullshit            0.300000                0.200000\n214  4460  2019-10-23 11:34:10                                   Vitória do Vasco                                    Vasco's Victory            0.000000                0.000000\n215  4461  2019-10-23 11:40:13                              As pérolas do Carluxo                               The Pearls of Carlux            0.000000                0.000000\n216  4462  2019-10-23 12:18:50                      O desastre do desgoverno Rsrs                       The disaster of misrule Rsrs            0.000000                0.000000\n217  4463  2019-10-23 12:24:17  tô tentando agendar a montagem do meu guarda r...  I'm trying to schedule the fitting of my wardr...            0.225000                0.450000\n218  4464  2019-10-23 12:29:32  A Lu anunciando desconto para celular para aju...  Lu announcing mobile discount to help us worke...            0.000000                0.000000\n219  4465  2019-10-23 12:40:40  A falta de responsabilidade da com o comprador...  The lack of responsibility to the buyer is sur...           -0.125000                0.950000\n220  4466  2019-10-23 12:51:55  Queria saber se a vem para inauguração do em B...  I would like to know if you are coming to the ...            0.200000                0.200000\n221  4467  2019-10-23 12:55:27                          Descontos de mil reais Lu                        Thousand reais discounts Lu            0.000000                0.000000\n222  4468  2019-10-23 13:11:18                                  Promoção do grill                                    Grill promotion            0.000000                0.000000\n223  4469  2019-10-23 13:30:38                       Cupom de Mil reais no magalu                    Thousand reais coupon in magalu            0.000000                0.000000\n224  4470  2019-10-23 13:31:35  PESSOAS COMEMORANDO O FELIZ DIA DA FORÇA AÉREA...  PEOPLE CELEBRATING THE HAPPY DAY OF THE BRAZIL...            0.800000                1.000000\n225  4471  2019-10-23 13:39:58                                        Cupom da lu                                          Lu coupon            0.000000                0.000000\n226  4472  2019-10-23 13:40:02  Comprei um tablet esses dias e não tinha a opç...  I bought a tablet these days and did not have ...            0.000000                0.050000\n227  4473  2019-10-23 13:43:04  Bom dia lu eu gosto de ver coisas emgracadas p...  Good morning lu I like to see funny things for...            0.416667                0.566667\n228  4474  2019-10-23 13:52:09                   a minha lu favorita dando cupons                      my favorite lu giving coupons            0.500000                1.000000\n229  4475  2019-10-23 14:19:48  Fiz uma compra na dia 11 10 fui ver o que está...  I made a purchase on the 11th 10 I went to see...            0.000000                1.000000\n230  4476  2019-10-23 14:26:30  Comprei um produto na que apresentou defeito c...  I bought a product that was defective with a l...            0.450000                0.762500\n231  4477  2019-10-23 14:53:15                                      Gol do Gabgol                                        Gabgol Goal            0.000000                0.000000\n232  4478  2019-10-23 15:18:54  Enviei o número do pedido e meu CPF e até agor...  I submitted the order number and my social sec...            0.066667                0.533333\n233  4479  2019-10-23 15:36:30                                    Cupom da magalu                                      Magalu coupon            0.000000                0.000000\n234  4480  2019-10-23 15:40:11  O carro do Magalu me entregando três presentes...  Magalu's car giving me three beautiful gifts T...            0.850000                1.000000\n235  4481  2019-10-23 16:00:00  Ao lado do juiz o rapper realiza o projeto Tra...  Beside the judge, the rapper performs the Tram...            0.000000                0.000000\n236  4482  2019-10-23 16:48:18         E a que vende caneca do twt com foto do do   And the one that sells twt mug with photo of the            0.000000                0.000000\n237  4483  2019-10-23 16:55:39  Comprei um secador no e estou amando a Lu me i...  I bought a dryer on and I am loving Lu informi...            0.600000                0.950000\n238  4484  2019-10-23 17:19:17  Estou meio apertado dia 26 10 é meu aniversári...  I'm a little cramped day 26 10 is my birthday ...           -0.187500                0.500000\n239  4485  2019-10-23 17:25:43  Experiencia negativa com a 1 compra na Um camp...  Negative experience with 1 purchase in A field...           -0.300000                0.400000\n240  4552  2019-10-23 17:49:31      CUPOM R 1 000 00 da LU DO MAGALU É PEDI MUITO           MAGALU LU COUPON R 000 000 IS VERY ASKED            0.200000                0.300000\n241  4553  2019-10-23 17:50:01                         Também quero um notbook Lu                           I also want a notbook Lu            0.000000                0.000000\n242  4554  2019-10-23 18:08:05                              Abaixa o preço do PS4                        Lowers the price of the PS4            0.000000                0.000000\n243  4555  2019-10-23 18:08:28    Como quero ganhar os produtos da Lu quero muito        How I want to win Lu products I really want            0.500000                0.300000\n244  4556  2019-10-23 18:08:41  Estou ainda aguardado uma resposta Até o momen...  I'm still awaiting a reply No reply yet and no...            0.000000                0.000000\n245  4557  2019-10-23 18:51:45  lgzn Brasil Mas é diferente Gui me cansa ver a...  lgzn Brazil But it is different Gui tired to s...            0.137500                0.550000\n246  4558  2019-10-23 18:53:25  lgzn Brasil Claro que a gente entra em papos s...  lgzn Brasil Of course we get into chats about ...            0.285714                0.535714\n247  4559  2019-10-23 19:20:29  Magalu Ta tudo bem Ainda to com aquele problem...  Magalu It's ok I'm still with that problem Hel...            0.500000                0.500000\n248  4560  2019-10-23 19:42:16  Maravilhoso Agora só falta um botão pra deixar...  Wonderful Now there's only one button left to ...            0.333333                0.666667\n249  4561  2019-10-23 19:51:39  Promoções de boneca inflável Vai ter na Black ...  Inflatable Doll Promotions Will Have At Black ...           -0.166667                0.433333\n250  4562  2019-10-23 20:03:46  paguei a fatura do cartão no dia certo e me li...  I paid the card bill on the right day and they...            0.285714                0.535714\n251  4563  2019-10-23 20:09:50  FINALMENTE Não é como se a solução fosse simpl...  FINALLY It's not like the solution is to simpl...            0.033333                0.676190\n252  4564  2019-10-23 20:40:25  Desde 16 de outubro estou aguardando um posici...  Since October 16th I am waiting for a position...            0.000000                0.000000\n253  4565  2019-10-23 21:15:13  amanhã é meu niver me dá um cupom desconto pra...  tomorrow is my birthday gives me a discount co...            0.000000                0.000000\n254  4566  2019-10-23 21:32:16  Eu não posso sair do grupo mas quero ele arqui...  I can not leave the group but I want it filed ...            0.136364                0.454545\n255  4567  2019-10-23 21:32:40  querida comprei dois produtos com vocês para d...  baby bought two products from you to give as a...            0.091667                0.391667\n256  4568  2019-10-23 21:45:12  RT Você prefere o Waze ou o Google Maps na hor...  RT Do you prefer Waze or Google Maps when navi...            0.136364                0.454545\n257  4569  2019-10-23 22:02:42  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n258  4570  2019-10-23 22:03:15  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n259  4571  2019-10-23 22:03:19  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n260  4572  2019-10-23 22:03:36  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n261  4573  2019-10-23 22:03:40  Lu Jacquin Kkkkkkkkkkkk Lá é Pesadelo Aqui é P...  Lu Jacquin Kkkkkkkkkkkk There's a Nightmare Th...            0.000000                0.000000\n262  4574  2019-10-23 22:05:24  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n263  4575  2019-10-23 22:07:26       Consigo enviar meu Currículo por aqui Olá Lu                 I can send my Resume here Hello Lu            0.000000                0.000000\n264  4576  2019-10-23 22:13:47  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n265  4577  2019-10-23 22:33:42  RT COMO ASSIM VOCÊS DESLIGAM O FREEZER À NOITE...  RT HOW DO YOU TURN FREEZER OFF AT NIGHTEE Calm...            0.159488                0.516216\n266  4578  2019-10-23 22:40:08                              Eu AMO MAGAZINE LUIZA                              I LOVE MAGAZINE LUIZA            0.500000                0.600000\n267  4579  2019-10-23 22:55:17  É com grande alívio que venho aqui dizer q meu...  It is with great relief that I come here to sa...            0.122222                0.691667\n268  4580  2019-10-23 23:05:14  RT Você prefere o Waze ou o Google Maps na hor...  RT Do you prefer Waze or Google Maps when navi...            0.136364                0.454545\n269  4581  2019-10-23 23:13:40                Olhei rápido pensei que era a Lu do            I looked quickly thought it was Lu from            0.333333                0.500000\n270  4582  2019-10-23 23:18:55  Lu o produto foi entregue mas p outra pessoa N...  Lu the product was delivered but p someone els...            0.050000                0.566667\n271  4583  2019-10-23 23:23:31  foi irresponsabilidade de uma loja parceira de...  it was irresponsible of a partner store of you...            0.000000                0.000000\n272  4584  2019-10-23 23:24:56  Eu comprei um produto ontem a noite e chegou h...  I bought a product last night and arrived this...            0.100000                0.133333\n273  4585  2019-10-23 23:54:00                                     Gol do Gabigol                                       Gabigol Goal            0.000000                0.000000\n274  4586  2019-10-24 18:33:22        Oi lu por obséquio você poderia bugar agora                   Hi lu please could you bugar now            0.000000                0.000000\n275  4587  2019-10-24 18:34:05  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n276  4588  2019-10-24 18:34:18  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n277  4589  2019-10-24 18:34:19  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n278  4590  2019-10-24 18:34:43  Eu acho a mais digital influencer do que essa ...  I think more digital influencer than this Miqu...            0.250000                0.250000\n279  4591  2019-10-24 18:35:54  Eu tô quase indo no psicólogo msm precisando d...  I'm almost going to the msm psychologist in ne...            0.136364                0.454545\n280  4592  2019-10-24 18:36:09  psicóloga Quando a Lu posta no Twitter o que a...  psychologist When Lu posts on Twitter what we ...            0.000000                0.166667\n281  4593  2019-10-24 18:36:20  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n282  4594  2019-10-24 18:37:45                          Psicóloga cadê o cupom Lu                 Psychologist Where's the Lu Coupon            0.000000                0.000000\n283  4595  2019-10-24 18:37:53  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n284  4596  2019-10-24 18:37:59  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n285  4597  2019-10-24 18:38:43  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n286  4598  2019-10-24 18:39:07  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n287  4599  2019-10-24 18:39:41  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n288  4600  2019-10-24 18:40:14  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n289  4601  2019-10-24 18:40:30  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n290  4602  2019-10-24 18:40:33  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n291  4603  2019-10-24 18:41:06  Grupo com os cupons bugs da Entra pq se sair c...  Group with the bugs coupons of Entra because i...            0.000000                0.000000\n292  4604  2019-10-24 18:41:32                  Manda cupão lu nunca te pedi nada      Send coupon lu I never asked you for anything            0.000000                0.000000\n293  4605  2019-10-24 18:42:41       Até a psicóloga quer cupom Lu não deu pra tu  Even the psychologist wants coupon Lu didn't g...            0.200000                0.100000\n294  4606  2019-10-24 18:42:51  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n295  4607  2019-10-24 18:45:05  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n296  4608  2019-10-24 18:45:19  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n297  4609  2019-10-24 18:45:38  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n298  4610  2019-10-24 18:45:55  Estou querendo fazer parte do magazine e vc ma...  I'm wanting to be part of the magazine and you...            0.000000                0.100000\n299  4611  2019-10-24 18:48:29  Lu vc é divina estou ansiosa pelo black post d...  Lu u are divine I'm looking forward to the bla...           -0.166667                0.433333\n300  4612  2019-10-24 18:54:22  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n301  4613  2019-10-24 18:57:22  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n302  4614  2019-10-24 19:02:38  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n303  4615  2019-10-24 19:06:06                 Não tem jeito Lu Peço cupom sempre                      No way Lu I always ask coupon            0.000000                0.000000\n304  4616  2019-10-24 19:06:56  essa psicóloga ta por fora das promoções da ma...  this psychologist is out of magazine promotion...            0.000000                0.000000\n305  4617  2019-10-24 19:09:20                                 cadê meu follow Lu                              where is my follow Lu            0.000000                0.000000\n306  4618  2019-10-24 19:10:48  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n307  4619  2019-10-24 19:18:44  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n308  4620  2019-10-24 19:24:13                      sim mulher pf tenha dó de mim                           yes woman please pity me           -0.100000                0.200000\n309  4621  2019-10-24 19:24:40  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n310  4622  2019-10-24 19:31:33  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n311  4623  2019-10-24 19:32:35  Não caiam nesse site de compras mo furada comp...  Do not fall into this shopping site mo holada ...            0.000000                0.000000\n312  4624  2019-10-24 19:37:37  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n313  4625  2019-10-24 19:39:22  preciso de cupom acabei de ser demitido de uma...  I need a coupon I just got fired from a magazi...            0.000000                0.000000\n314  4626  2019-10-24 19:41:02  Dona Lu libera cupons Quero gastar meu 13 Só d...  Dona Lu releases coupons I want to spend my 13...            0.000000                0.000000\n315  4627  2019-10-24 19:45:21  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n316  4628  2019-10-24 19:45:42  Pra que isso lu Aumentar o preço antes da Blac...  So that lu Increase the price before Black Fri...           -0.166667                0.433333\n317  4629  2019-10-24 19:51:56  Podia era me responder Pq até agora nada do me...  Could you answer me Cause so far none of my qu...            0.100000                1.000000\n318  4630  2019-10-24 19:51:59  olhando aqui as promoções da minha amiga Magal...  looking here the promotions of my friend Magal...            0.400000                0.433333\n319  4631  2019-10-24 19:52:16  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n320  4632  2019-10-24 20:03:13                                   já queroooooo Lu                                  I already want Lu            0.000000                0.000000\n321  4633  2019-10-24 20:03:49  ai lu kkkkkkkpergunta aleatoria vc e a sao amigas   oh lu kkkkkkkper random question you are friends           -0.500000                0.500000\n322  4634  2019-10-24 20:13:51                                        Da cupom Lu                                 From the Lu coupon            0.000000                0.000000\n323  4635  2019-10-24 20:17:06  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n324  4636  2019-10-24 20:18:16  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n325  4637  2019-10-24 20:25:05  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n326  4638  2019-10-24 20:25:41  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n327  4639  2019-10-24 20:26:16      Lu preciso de ajuda pode conversar cmg por DM                    Lu need help can talk cmg by DM            0.000000                0.000000\n328  4640  2019-10-24 20:29:08  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n329  4641  2019-10-24 20:30:13  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n330  4642  2019-10-24 20:31:09  ei dona magalu eu não aguento mais sms de inau...  hey dona magalu i can't stand the opening sms ...            0.000000                0.000000\n331  4643  2019-10-24 20:37:17  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n332  4644  2019-10-24 20:48:25  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n333  4645  2019-10-24 20:52:05  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n334  4646  2019-10-24 20:54:02  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n335  4647  2019-10-24 20:57:42  psicóloga Quando a Lu posta no Twitter o que a...  When Lu posts on Twitter what we do I lower pr...            0.000000                0.125000\n336  4648  2019-10-24 21:00:27  Lu me tira uma dúvida a Samsung 50RU7100 tem l...  Lu asks me a question the Samsung 50RU7100 has...            0.142857                0.761905\n337  4649  2019-10-24 21:05:30  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n338  4650  2019-10-24 21:13:45  MELHOR DESCONTO QUE GANHEI ATÉ HOJE FOI O DO C...  BEST DISCOUNT I HAVE EARNED TODAY CIRIOOOOO ev...            0.497222                0.266667\n339  4651  2019-10-24 21:14:30            Sou MAGAZINE VOCE EEEEEEESOU O KALLMART                   I'm MAGAZINE YOU EEEEEE KALLMART            0.000000                0.000000\n340  4652  2019-10-24 21:14:54         RT Sou MAGAZINE VOCE EEEEEEESOU O KALLMART                RT I'm MAGAZINE YOU EEEEEE KALLMART            0.000000                0.000000\n341  4653  2019-10-24 21:17:51  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n342  4654  2019-10-24 21:19:41         E este preço lu Vai abaixar antes da Black           And this price will go down before Black           -0.161111                0.361111\n343  4655  2019-10-24 21:21:03  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n344  4656  2019-10-24 21:23:05  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n345  4657  2019-10-24 21:29:11  LU PEÇO PELA AMOR DE DEUS ESSAS CUECAS TENHO 3...  LU ASK FOR GOD'S LOVE THESE PANTIES I HAVE 3 F...            0.425000                0.575000\n346  4658  2019-10-24 21:31:05        23 reais de frete tá de sacanagem né magalu            23 reais freight is slutty right magalu            0.285714                0.535714\n347  4659  2019-10-24 21:32:56  Que pena que freto é mais caro que produto vcs...  Too bad that charter is more expensive than pr...           -0.075000                0.666667\n348  4660  2019-10-24 21:33:26  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n349  4661  2019-10-24 21:34:37  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n350  4662  2019-10-24 21:51:15  Todo dia nós temos um motivo diferente para vo...  Every day we have a different reason for you t...            0.156566                0.573737\n351  4663  2019-10-24 21:51:37  RT Todo dia nós temos um motivo diferente para...  RT Every day we have a different reason for yo...            0.000000                0.600000\n352  4664  2019-10-24 21:54:38  só queria um descontinho ou frete grátis para ...  I just wanted a discount or free shipping to b...            0.200000                0.666667\n353  4665  2019-10-24 22:03:52                             Comprei lu não resisti                      I bought lu I couldn't resist            0.000000                0.000000\n354  4666  2019-10-24 22:07:17  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n355  4667  2019-10-24 22:13:39  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n356  4668  2019-10-24 22:18:48       Posso mandar o número do meu pedido por aqui                    Can I send my order number here            0.000000                0.000000\n357  4669  2019-10-24 22:31:45  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n358  4670  2019-10-24 22:34:17  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n359  4671  2019-10-24 22:38:18  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n360  4672  2019-10-24 22:40:53  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n361  4673  2019-10-24 22:42:58  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n362  4674  2019-10-24 22:47:02  Só se for o comprovante do seu olho do cu pq t...  Only if it is the proof of your asshole eye be...            0.000000                0.555556\n363  4675  2019-10-24 22:53:08  Gostaria de deixar minha insatisfação com o pé...  I would like to leave my dissatisfaction with ...           -0.100000                0.652381\n364  4676  2019-10-24 22:53:27  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n365  4677  2019-10-24 22:56:22  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n366  4678  2019-10-24 22:58:31          Magalu amiga me da um desconto no celular           Magalu friend gives me a mobile discount            0.000000                0.000000\n367  4679  2019-10-24 23:18:35  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n368  4680  2019-10-24 23:32:27  Alguém precisa desinstalar o app do URGENTE Já...  Someone needs to uninstall the app from URGENT...           -0.600000                0.900000\n369  4681  2019-10-24 23:40:17  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n370  4682  2019-10-24 23:50:17  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n371  4683  2019-10-24 23:53:13  HAHAHAHAHAH Eu comprei essa fechadura digital ...  HAHAHAHAHAH I bought this digital lock with th...            0.100000                0.300000\n372  4684  2019-10-24 23:54:10  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n373  4685  2019-10-24 23:55:39  Estou muito puto Comprei uma TV 4K da do jeito...  I'm very pissed I bought a 4K TV just the way ...            0.200000                0.300000\n374  4686  2019-10-25 02:25:05  todo mundo em casa tinha esquecido do aniversá...  everyone at home had forgotten about my father...            0.285714                0.535714\n375  4687  2019-10-25 02:25:51  O app do é perfeito O foda é que não tenho din...  The app is perfect The fuck is I have no money...            0.233333                0.533333\n376  4688  2019-10-25 02:36:37  Infelizmente depois de tantos transtornos já e...  Unfortunately after so many inconveniences I a...            0.000000                0.750000\n377  4689  2019-10-25 02:43:43  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n378  4690  2019-10-25 03:23:33  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n379  4691  2019-10-25 04:50:30  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n380  4692  2019-10-25 06:33:57               Melhor loja que dá cupom é na MagaLu                      Best coupon shop is at MagaLu            1.000000                0.300000\n381  4693  2019-10-25 08:51:35  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n382  4694  2019-10-25 09:01:53               A qualidade do produto e o preço kkk                      Product quality and price kkk            0.000000                0.000000\n383  4695  2019-10-25 09:14:19  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n384  4696  2019-10-25 09:15:47             As especificações completas do produto                The complete product specifications            0.100000                0.400000\n385  4697  2019-10-25 09:22:08  Curiosidade em saber se vai reduzir o valor do...  Curious to know if will reduce the value of Ro...           -0.100000                1.000000\n386  4698  2019-10-25 09:35:50  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n387  4699  2019-10-25 09:37:31  Qual o barulho que o mosquito houve do repelen...  What was the noise the mosquito made from the ...           -0.900000                1.000000\n388  4700  2019-10-25 09:40:24  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n389  4701  2019-10-25 10:05:44  Lu da um cuponzin pra eu comprar meu notebook ...  Lu gives a cuponzin for me to buy my notebook ...            0.000000                0.000000\n390  4702  2019-10-25 10:24:09  Bom dia Lu sua lindaaaaa Muito bom te encontra...  Good morning Lu sua lindaaaaa Very good to mee...            0.536667                0.493333\n391  4703  2019-10-25 10:27:12  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n392  4704  2019-10-25 10:37:53  só queria um descontinho ou frete grátis para ...  I just wanted a discount or free shipping to b...            0.200000                0.666667\n393  4705  2019-10-25 10:45:39                   Lu manda salve para o Küsterveso                        Lu sends save to Küsterveso            0.000000                0.000000\n394  4706  2019-10-25 11:01:30  Quando assunto é tecnologia morro de curiosida...  When it comes to technology, I'm curious about...           -0.050000                0.500000\n395  4707  2019-10-25 11:07:16  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n396  4708  2019-10-25 11:18:26  Lu comprei uma cama box e veio sem os pés Oq e...  Lu bought a box bed and came without his feet ...            0.000000                0.000000\n397  4709  2019-10-25 11:27:57  Minha curiosidade e quando vem cupom top do ip...  My curiosity and when it comes top iphone 11 c...            0.500000                0.500000\n398  4710  2019-10-25 11:28:52  RT Gente olha que oferta imperdível pra dar aq...  RT Guys look what a must see to give that rene...            0.250000                0.250000\n399  4711  2019-10-25 11:40:36  Eu quero saber quando a Lu vai devolver meu di...  I want to know when Lu will return my money fr...            0.000000                0.000000\n400  4712  2019-10-25 11:49:14                  1000 não é nada para a mãe magalu                     1000 is nothing for mom magalu            0.000000                0.000000\n401  4713  2019-10-25 11:53:06                 Bom dia lu porque os celular trava       Good morning lu because the cell phone hangs            0.700000                0.600000\n402  4714  2019-10-25 11:54:31  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n403  4715  2019-10-25 11:59:54  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n404  4716  2019-10-25 12:15:38  Lu to precisando dos meu produtos urgenteee Te...  I'm in need of my urgent products and I could ...            0.000000                0.000000\n405  4717  2019-10-25 12:16:14                          Cupom de 1000 reais da lu                                  1000 reais coupon            0.000000                0.000000\n406  4718  2019-10-25 12:30:26  E eu que tô morrendo de amores pela primeiro p...  And I'm dying in love for the first time becau...            0.640000                0.786667\n407  4719  2019-10-25 12:43:16              Preciso iPhone barato lu com urgência                    I need cheap iPhone lu urgently            0.400000                0.700000\n408  4720  2019-10-25 12:51:24  Será se vai ter salgadinho e doce grátis na in...  Will be if you will have free snacks and candy...            0.400000                0.800000\n409  4721  2019-10-25 12:58:04  Oi Lu queria saber pq a réplica do Nintendo nã...  Hi Lu wanted to know why the Nintendo replica ...            0.000000                0.000000\n410  4722  2019-10-25 13:03:23  Super bacana saber que a Motorola está inovand...  Cool to know that Motorola is innovating but t...            0.350000                0.650000\n411  4723  2019-10-25 13:11:22  Lu sera que meu pedido ainda vai demorar fui a...  Lu will be that my order will still take I was...            0.168182                0.327273\n412  4724  2019-10-25 13:30:43  entrei em uma loja e vi o patinete elétrico e ...  I went into a store and saw the electric scoot...            0.208000                0.702000\n413  4725  2019-10-25 13:49:48  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n414  4726  2019-10-25 13:49:52  Elogiei antes da hora veio faltando os espelho...  I complimented before the time came missing th...           -0.200000                0.050000\n415  4727  2019-10-25 13:50:03                      Lu cê para a gente quer cupom                           Lu cê for us want coupon            0.000000                0.000000\n416  4728  2019-10-25 13:50:55  Quando é pra elogiar tem que elogiar sim Entre...  When to praise you have to praise yes Delivery...            0.000000                0.000000\n417  4729  2019-10-25 13:59:21  Psicóloga Quando a Lu posta no Twitter o que a...  Psychologist When Lu posts on Twitter what we ...            0.000000                0.000000\n418  4730  2019-10-25 14:10:55  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n419  4731  2019-10-25 14:14:49  Lu pode me informar a potência dos processador...  Lu can let me know the power of the processors...            0.000000                0.000000\n420  4732  2019-10-25 14:16:33  Bom Dia Tive um problema ao comprar um item do...  Good morning I had a problem buying an item fr...           -0.033333                0.600000\n421  4733  2019-10-25 14:22:01  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n422  4734  2019-10-25 14:29:54  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n423  4735  2019-10-25 14:36:56  Muito obrigado lu querida despois eu vou la da...  Thanks a lot honey darling then I'll take a lo...            0.450000                0.400000\n424  4736  2019-10-25 14:38:37  Hoje nós resolvemos falar sobre uma atualizaçã...  Today we decided to talk about an update we ma...            0.025000                0.600000\n425  4737  2019-10-25 14:45:06     lembrou do meu desaniversário kkkkkkkkkkkkkkkk            remembered my birthday kkkkkkkkkkkkkkkk            0.000000                0.000000\n426  4738  2019-10-25 14:47:10  Manda uma DM pra mim magalu recebi um cupom co...  Send me a DM magalu got a coupon with less val...           -0.166667                0.066667\n427  4739  2019-10-25 14:48:15         Lu o Brasil não te merece eu não te mereço  Lu Brazil doesn't deserve you I don't deserve you            0.000000                0.000000\n428  4740  2019-10-25 14:50:39  Miller Bom dia Informamos que a conduta do for...  Miller Bom dia We inform that the conduct of t...           -0.054545                0.366667\n429  4741  2019-10-25 14:59:00  Lu bom dia tô querendo um cupom para pneu do m...  Lu good morning I'm wanting a coupon for my ca...            0.700000                0.600000\n430  4742  2019-10-25 15:00:56  Palestra sobre a transformação digital na fgv ...  Lecture on digital transformation at fgv clav2...            0.000000                0.000000\n431  4743  2019-10-25 15:01:17  Eu comprei o guarda roupa de casal na pensando...  I bought the couple wardrobe thinking about sh...           -0.033333                0.333333\n432  4744  2019-10-25 15:47:50                      ta tao esbelta nesse video lu                   are you so slim in this video lu            0.000000                0.000000\n433  4745  2019-10-25 15:53:50  Então se a troca fosse do em 7 dias não teria ...  So if the exchange had been in 7 days would no...            0.521429                0.633929\n434  4746  2019-10-25 15:55:38  Também quero saber quando a magalu irá devolve...  I also want to know when magalu will return th...            0.100000                1.000000\n435  4747  2019-10-25 16:00:42  A inauguração do em Santahell fez a concorrênc...  Santahell's opening made competition change pitch            0.000000                0.000000\n436  4748  2019-10-25 16:03:02  RT A inauguração do em Santahell fez a concorr...  RT Santahell's inauguration made competition c...            0.000000                0.000000\n437  4749  2019-10-25 16:05:15  ei diz pra mim se essa oferta aqui é de verdad...  hey tell me if this offer is for real because ...            0.200000                0.300000\n438  4750  2019-10-25 16:41:18  COMO NINGUÉM TA CHOCADO COM A LU FALANDO MEU P...       HOW NO ONE SHOCKED WITH LU SPEAKING MY PAAAI           -0.700000                0.800000\n439  4751  2019-10-25 16:49:26  Lélio Bertoni do fala sobre o uso da assinatur...  Lélio Bertoni speaks about the use of electron...           -0.100000                0.200000\n440  4752  2019-10-25 16:49:43  A assinatura eletrônica foi uma solução rápida...  The electronic signature was a quick and pract...            0.158333                0.431250\n441  4753  2019-10-25 17:18:43  Lu comprei dois produtos e além de demorar mui...  Lu bought two products and in addition to take...           -0.225000                0.400000\n442  4754  2019-10-25 17:19:21  Qual é Lu Solta aquele cupom manero pra eu com...  What is Lu Loose that manero coupon for me to ...            0.161538                0.534615\n443  4755  2019-10-25 17:22:50  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n444  4756  2019-10-25 17:26:19  e a não faz naaaadaaaaaaaaparentemente eu comp...  and na naaaaaaaaaa apparently I bought on thei...            0.050000                0.350000\n445  4757  2019-10-25 17:40:51                  O que é chamado clock do hardware                      What is called hardware clock            0.000000                0.000000\n446  4758  2019-10-25 17:47:20  Lu eu sempre compro grift card aqui no Paraná ...  Lu I always buy grift card here in Paraná can ...           -0.187500                0.500000\n447  4759  2019-10-25 17:53:38  OI GENTE EVITE COMPRAR NO SITE DO MAGAZINE LUI...  Hi Guys avoid shopping on the site of MAGAZINE...            0.000000                0.000000\n448  4760  2019-10-25 17:57:43              O número do pedido é 7749500508076405               The order number is 7749500508076405            0.000000                0.000000\n449  4761  2019-10-25 18:23:17  Estou a dias tentando contato com vocês em rel...  I'm just trying to contact you about the produ...           -0.500000                1.000000\n450  4762  2019-10-25 18:37:33  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n451  4763  2019-10-25 18:38:37  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n452  4764  2019-10-25 19:09:43  A Cielo participou de um dos maiores eventos s...  Cielo participated in one of the largest payme...            0.000000                0.000000\n453  4765  2019-10-25 19:22:44  RT Quer aprender a preservar a bateria do seu ...  RT Want to learn how to preserve your notebook...           -0.025000                0.233333\n454  4766  2019-10-25 19:23:52  RT Quer aprender a preservar a bateria do seu ...  RT Want to learn how to preserve your notebook...           -0.025000                0.233333\n455  4767  2019-10-25 19:32:13  ta triste me chama de magazine luiza e vem ser...  you're sad call me magazine luiza and come be ...            0.150000                1.000000\n456  4768  2019-10-25 19:36:04  O problema da hashtag LulaMandanteDoCrime é qu...  The problem with the hashtag LulaMandanteDoCri...           -0.650000                0.650000\n457  4769  2019-10-25 19:43:20               Lu manda uns cupons de desconto pfvr            Lu sends you some pfvr discount coupons            0.000000                0.000000\n458  4770  2019-10-25 19:48:40  como faço para denunciar a equipe do que fica ...  how do I report to the team that keeps calling...            0.000000                0.000000\n459  4771  2019-10-25 19:55:45                        Lu quero cupons de desconto                           Lu want discount coupons            0.000000                0.000000\n460  4772  2019-10-25 20:00:49  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n461  4773  2019-10-25 20:05:07  Você está certa deveria ter comprado na magaZi...  You are right should have bought in magaZine L...            0.285714                0.535714\n462  4774  2019-10-25 20:30:57  Estranho não foi eu que apaguei meus twits Def...  Strange I didn't erase my twits PT Bandit Defe...           -0.050000                0.150000\n463  4775  2019-10-25 20:47:47  Eu super fazia campanha pra Até vir na inaugur...  I was super campaigning until I came to the op...            0.234848                0.560606\n464  4776  2019-10-25 21:28:30  dona Lu muito obrigado por atrasar mais QUATRO...  Dona Lu thank you very much for delaying four ...            0.380000                0.380000\n465  4777  2019-10-25 21:31:53                               Lu você vende Xiaomi                                 Lu you sell Xiaomi            0.000000                0.000000\n466  4778  2019-10-25 21:55:57                    Abaixa o preço do iPad pra elas                      Lower the iPad price for them            0.000000                0.000000\n467  4779  2019-10-25 21:58:16  Comprei um aspirador de pó na magazine Luiza e...  I bought a vacuum cleaner in Luiza magazine an...           -0.236111                0.350000\n468  4780  2019-10-25 22:15:12  Achei a peça dentro do aspirador mas mto obrig...  I found the piece inside the vacuum cleaner bu...           -0.027083                0.350000\n469  4781  2019-10-25 22:40:07  Qual será o valor do G7 play no mês da Black F...  What will be the value of G7 play in Black Fri...           -0.166667                0.433333\n470  4782  2019-10-25 22:58:59  RT psicóloga Quando a Lu posta no Twitter o qu...  RT psychologist When Lu posts on Twitter what ...            0.000000                0.000000\n471  4783  2019-10-25 23:06:03  Muito triste com péssimo pós venda do Uma empr...  Very sad with bad after sales of A company tha...           -0.675000                0.833333\n472  4784  2019-10-25 23:08:15  comprei uma geladeira que veio primeiro com vo...  I bought a refrigerator that came first with t...           -0.216667                0.544444\n473  4785  2019-10-25 23:35:50  Acho bem parecida com você Lu a Nicole de Boer...  I think it's very similar to you Lu the Nicole...           -0.100000                0.460000\n474  4786  2019-10-28 01:46:13   Ajuda nos Lu to precisando de Smartphone urgente              Helps Us Needing an Urgent Smartphone            0.000000                0.000000\n475  4787  2019-10-28 03:03:29  Hey Lu quando tu vai oficializar teu relaciona...  Hey Lu when are you going to officialize your ...            0.000000                0.000000\n476  4788  2019-10-28 03:19:20  RT Hey Lu quando tu vai oficializar teu relaci...  RT Hey Lu when are you going to officialize yo...            0.000000                0.000000\n477  4789  2019-10-28 04:22:28  RT Bom dia Complete a frase para eu curtir mui...  RT Good morning Complete the sentence for me t...            0.550000                0.450000\n478  4790  2019-10-28 04:22:30  RT Gente neste vídeo eu comparo e testo dois s...  RT People in this video I compare and test two...            0.600000                0.900000\n479  4791  2019-10-28 04:22:32  RT Bom dia Marque aqui dois amigos para um del...  RT Good morning Mark here two friends for one ...            0.287500                0.487500\n480  4792  2019-10-28 04:22:33  RT Quer aprender a preservar a bateria do seu ...  RT Want to learn how to preserve your notebook...           -0.025000                0.233333\n481  4793  2019-10-28 04:22:36  RT Você já mandou uma foto pelo WhatsApp e per...  RT You already sent a photo on WhatsApp and re...            0.000000                0.000000\n482  4794  2019-10-28 04:22:39  RT Gente olha que oferta imperdível pra dar aq...  RT Guys look what a must see to give that rene...            0.250000                0.250000\n483  4795  2019-10-28 06:42:53  PERDI A NOÇÃO DE EM BREVE DE VCS A PARTIR DO M...  LOST THE CONCEPT OF SOON OF YOU FROM THE TIME ...           -0.250000                0.500000\n484  4796  2019-10-28 06:43:45  Eu já fui hostilizada por 7 atendentes imbecis...  I've been harassed by 7 moronic robot attendan...           -0.243333                0.506667\n485  4797  2019-10-28 10:11:22  RT Bom dia Tão bom a sensação de ver tudo orga...  RT Good morning It feels so good to see everyt...            0.527143                0.637143\n486  4798  2019-10-28 10:44:25  de vários cupons esse final de semana segue a ...  from several coupons this weekend follows the ...            0.000000                0.000000\n487  4799  2019-10-28 11:06:30  exigindo que seus funcionários cantem o hino n...  requiring their employees to sing the national...            0.000000                0.000000\n488  4800  2019-10-28 11:18:57  RT Bom dia Tão bom a sensação de ver tudo orga...  RT Good morning It feels so good to see everyt...            0.527143                0.637143\n489  4801  2019-10-28 11:30:27  Oi Lu o frete é fora da realidade as vezes o p...  Hi Lu the freight is unrealistic sometimes the...           -0.125000                0.750000\n490  4802  2019-10-28 12:09:06  RT Bom dia Tão bom a sensação de ver tudo orga...  RT Good morning It feels so good to see everyt...            0.527143                0.637143\n491  4803  2019-10-28 12:39:37    onde encontro código de rastreio do meu produto          where can I find my product tracking code            0.000000                0.000000\n492  4804  2019-10-28 13:22:29  e eu q comprei uma saída pelo ap do pra minha ...  and I bought an exit for my sister-in-law's ap...            0.000000                0.000000\n493  4805  2019-10-28 13:44:17  Dona Lu me dá um cuponzinho pra eu comprar meu...  Dona Lu gives me a little coupon for me to buy...           -0.187500                0.500000\n"
     ],
     "output_type": "stream"
    }
   ],
   "source": [
    "merged_data = pd.concat([final, company_tweets_clean])\n",
    "print(merged_data.to_string())"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "outputs": [],
   "source": [
    "merged_data.to_csv(FILE_NAME.split('.')[0] + \"_clean.csv\", sep=',', encoding='utf-8')\n"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "source": [],
    "metadata": {
     "collapsed": false
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}